<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<TITLE>
InternalWorkbook (POI API Documentation)
</TITLE>


<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">

<SCRIPT type="text/javascript">
function windowTitle()
{
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="InternalWorkbook (POI API Documentation)";
    }
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>

</HEAD>

<BODY BGCOLOR="white" onload="windowTitle();">
<HR>


<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/InternalWorkbook.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/InternalSheet.UnsupportedBOFType.html" title="class in org.apache.poi.hssf.model"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/LineShape.html" title="class in org.apache.poi.hssf.model"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?org/apache/poi/hssf/model/InternalWorkbook.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="InternalWorkbook.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->

<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
org.apache.poi.hssf.model</FONT>
<BR>
Class InternalWorkbook</H2>
<PRE>
java.lang.Object
  <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by "><B>org.apache.poi.hssf.model.InternalWorkbook</B>
</PRE>
<HR>
<DL>
<DT><PRE><FONT SIZE="-1"><A HREF="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</A>
</FONT>public final class <B>InternalWorkbook</B><DT>extends java.lang.Object</DL>
</PRE>

<P>
Low level model implementation of a Workbook.  Provides creational methods
 for settings and objects contained in the workbook object.
 <P>
 This file contains the low level binary records starting at the workbook's BOF and
 ending with the workbook's EOF.  Use HSSFWorkbook for a high level representation.
 <P>
 The structures of the highlevel API use references to this to perform most of their
 operations.  Its probably unwise to use these low level structures directly unless you
 really know what you're doing.  I recommend you read the Microsoft Excel 97 Developer's
 Kit (Microsoft Press) and the documentation at http://sc.openoffice.org/excelfileformat.pdf
 before even attempting to use this.
<P>

<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel"><CODE>HSSFWorkbook</CODE></A></DL>
<HR>

<P>
<!-- =========== FIELD SUMMARY =========== -->

<A NAME="field_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Field Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#OLD_WORKBOOK_DIR_ENTRY_NAME">OLD_WORKBOOK_DIR_ENTRY_NAME</A></B></CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name of older (pre-Excel 97) Workbook streams, which
  aren't supported by HSSFWorkbook, only by
  <A HREF="../../../../../org/apache/poi/hssf/extractor/OldExcelExtractor.html" title="class in org.apache.poi.hssf.extractor"><CODE>OldExcelExtractor</CODE></A></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/SSTRecord.html" title="class in org.apache.poi.hssf.record">SSTRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#sst">sst</A></B></CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this contains a reference to the SSTRecord so that new stings can be added
 to it.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;java.lang.String[]</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#WORKBOOK_DIR_ENTRY_NAMES">WORKBOOK_DIR_ENTRY_NAMES</A></B></CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Normally, the Workbook will be in a POIFS Stream called 
  "Workbook".</TD>
</TR>
</TABLE>
&nbsp;
<!-- ========== METHOD SUMMARY =========== -->

<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Method Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#addBSERecord(org.apache.poi.ddf.EscherBSERecord)">addBSERecord</A></B>(<A HREF="../../../../../org/apache/poi/ddf/EscherBSERecord.html" title="class in org.apache.poi.ddf">EscherBSERecord</A>&nbsp;e)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#addName(org.apache.poi.hssf.record.NameRecord)">addName</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A>&nbsp;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;creates new name</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#addSSTString(org.apache.poi.hssf.record.common.UnicodeString)">addSSTString</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</A>&nbsp;string)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Adds a string to the SST table and returns its index (if its a duplicate
 just returns its index and update the counts) ASSUMES compressed unicode
 (meaning 8bit)</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#changeExternalReference(java.lang.String, java.lang.String)">changeExternalReference</A></B>(java.lang.String&nbsp;oldUrl,
                        java.lang.String&nbsp;newUrl)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Changes an external referenced file to another file.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#checkExternSheet(int)">checkExternSheet</A></B>(int&nbsp;sheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the extern sheet number for specific sheet number.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#checkExternSheet(int, int)">checkExternSheet</A></B>(int&nbsp;firstSheetNumber,
                 int&nbsp;lastSheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the extern sheet number for specific range of sheets.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#cloneDrawings(org.apache.poi.hssf.model.InternalSheet)">cloneDrawings</A></B>(<A HREF="../../../../../org/apache/poi/hssf/model/InternalSheet.html" title="class in org.apache.poi.hssf.model">InternalSheet</A>&nbsp;sheet)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Check if the cloned sheet has drawings.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#cloneFilter(int, int)">cloneFilter</A></B>(int&nbsp;filterDbNameIndex,
            int&nbsp;newSheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createBuiltInName(byte, int)">createBuiltInName</A></B>(byte&nbsp;builtInName,
                  int&nbsp;sheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates a NameRecord to represent a built-in region</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createCellXF()">createCellXF</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;creates a new Cell-type Extended Format Record and adds it to the end of
  ExtendedFormatRecords collection</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createDrawingGroup()">createDrawingGroup</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates a primary drawing group record.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createFormat(java.lang.String)">createFormat</A></B>(java.lang.String&nbsp;formatString)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates a FormatRecord, inserts it, and returns the index code.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createName()">createName</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;creates new name</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createNewFont()">createNewFont</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;creates a new font record and adds it to the "font table".</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/StyleRecord.html" title="class in org.apache.poi.hssf.record">StyleRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createStyleRecord(int)">createStyleRecord</A></B>(int&nbsp;xfIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates a new StyleRecord, for the given Extended
  Format index, and adds it onto the end of the
  records collection</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createWorkbook()">createWorkbook</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates an empty workbook object with three blank sheets and all the empty
 fields.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createWorkbook(java.util.List)">createWorkbook</A></B>(java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A>&gt;&nbsp;recs)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;read support  for low level
 API.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#doesContainsSheetName(java.lang.String, int)">doesContainsSheetName</A></B>(java.lang.String&nbsp;name,
                      int&nbsp;excludeSheetIdx)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Determines whether a workbook contains the provided sheet name.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/DrawingManager2.html" title="class in org.apache.poi.hssf.model">DrawingManager2</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findDrawingGroup()">findDrawingGroup</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finds the primary drawing group, if one already exists</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findFirstRecordBySid(short)">findFirstRecordBySid</A></B>(short&nbsp;sid)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the first occurance of a record matching a particular sid.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findFirstRecordLocBySid(short)">findFirstRecordLocBySid</A></B>(short&nbsp;sid)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the index of a record matching a particular sid.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findNextRecordBySid(short, int)">findNextRecordBySid</A></B>(short&nbsp;sid,
                    int&nbsp;pos)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the next occurance of a record matching a particular sid.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findSheetFirstNameFromExternSheet(int)">findSheetFirstNameFromExternSheet</A></B>(int&nbsp;externSheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finds the first sheet name by his extern sheet index</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findSheetLastNameFromExternSheet(int)">findSheetLastNameFromExternSheet</A></B>(int&nbsp;externSheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/BackupRecord.html" title="class in org.apache.poi.hssf.record">BackupRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getBackupRecord()">getBackupRecord</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the position of the backup record.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/ddf/EscherBSERecord.html" title="class in org.apache.poi.ddf">EscherBSERecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getBSERecord(int)">getBSERecord</A></B>(int&nbsp;pictureIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/PaletteRecord.html" title="class in org.apache.poi.hssf.record">PaletteRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getCustomPalette()">getCustomPalette</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the custom palette in use for this workbook; if a custom palette record
 does not exist, then it is created.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/DrawingManager2.html" title="class in org.apache.poi.hssf.model">DrawingManager2</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getDrawingManager()">getDrawingManager</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExFormatAt(int)">getExFormatAt</A></B>(int&nbsp;index)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the ExtendedFormatRecord at the given 0-based index</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExternalName(int, int)">getExternalName</A></B>(int&nbsp;externSheetIndex,
                int&nbsp;externNameIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExternalSheet(int)">getExternalSheet</A></B>(int&nbsp;externSheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExternalSheetIndex(java.lang.String, java.lang.String)">getExternalSheetIndex</A></B>(java.lang.String&nbsp;workbookName,
                      java.lang.String&nbsp;sheetName)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExternalSheetIndex(java.lang.String, java.lang.String, java.lang.String)">getExternalSheetIndex</A></B>(java.lang.String&nbsp;workbookName,
                      java.lang.String&nbsp;firstSheetName,
                      java.lang.String&nbsp;lastSheetName)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/FileSharingRecord.html" title="class in org.apache.poi.hssf.record">FileSharingRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFileSharing()">getFileSharing</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFirstSheetIndexFromExternSheetIndex(int)">getFirstSheetIndexFromExternSheetIndex</A></B>(int&nbsp;externSheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finds the (first) sheet index for a particular external sheet number.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFontIndex(org.apache.poi.hssf.record.FontRecord)">getFontIndex</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A>&nbsp;font)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the index of the given font</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFontRecordAt(int)">getFontRecordAt</A></B>(int&nbsp;idx)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the font record at the given index in the font table.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFormat(java.lang.String, boolean)">getFormat</A></B>(java.lang.String&nbsp;format,
          boolean&nbsp;createIfNotFound)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a format index that matches the passed in format.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/FormatRecord.html" title="class in org.apache.poi.hssf.record">FormatRecord</A>&gt;</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFormats()">getFormats</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the list of FormatRecords in the workbook.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/HyperlinkRecord.html" title="class in org.apache.poi.hssf.record">HyperlinkRecord</A>&gt;</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getHyperlinks()">getHyperlinks</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getLastSheetIndexFromExternSheetIndex(int)">getLastSheetIndexFromExternSheetIndex</A></B>(int&nbsp;externSheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finds the last sheet index for a particular external sheet number,
  which may be the same as the first (except for multi-sheet references)</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record">NameCommentRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameCommentRecord(org.apache.poi.hssf.record.NameRecord)">getNameCommentRecord</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A>&nbsp;nameRecord)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the name comment record</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameRecord(int)">getNameRecord</A></B>(int&nbsp;index)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the name record</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameXPtg(java.lang.String, int, org.apache.poi.ss.formula.udf.UDFFinder)">getNameXPtg</A></B>(java.lang.String&nbsp;name,
            int&nbsp;sheetRefIndex,
            <A HREF="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</A>&nbsp;udf)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameXPtg(java.lang.String, org.apache.poi.ss.formula.udf.UDFFinder)">getNameXPtg</A></B>(java.lang.String&nbsp;name,
            <A HREF="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</A>&nbsp;udf)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumberOfFontRecords()">getNumberOfFontRecords</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the number of font records</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumExFormats()">getNumExFormats</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the number of ExtendedFormat records contained in this workbook.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumNames()">getNumNames</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the total number of names</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumRecords()">getNumRecords</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumSheets()">getNumSheets</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;returns the number of boundsheet objects contained in this workbook.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/RecalcIdRecord.html" title="class in org.apache.poi.hssf.record">RecalcIdRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getRecalcId()">getRecalcId</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get or create RecalcIdRecord</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A>&gt;</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getRecords()">getRecords</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</A></B>(java.lang.String&nbsp;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the sheet's index</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSheetName(int)">getSheetName</A></B>(int&nbsp;sheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the name for a given sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSize()">getSize</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSpecificBuiltinRecord(byte, int)">getSpecificBuiltinRecord</A></B>(byte&nbsp;name,
                         int&nbsp;sheetNumber)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the Builtin NameRecord that matches the name and index
 There shouldn't be too many names to make the sequential search too slow</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSSTString(int)">getSSTString</A></B>(int&nbsp;str)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;given an index into the SST table, this function returns the corresponding String value</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/StyleRecord.html" title="class in org.apache.poi.hssf.record">StyleRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getStyleRecord(int)">getStyleRecord</A></B>(int&nbsp;xfIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the StyleRecord for the given
  xfIndex, or null if that ExtendedFormat doesn't
  have a Style set.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/WindowOneRecord.html" title="class in org.apache.poi.hssf.record">WindowOneRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getWindowOne()">getWindowOne</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/WriteAccessRecord.html" title="class in org.apache.poi.hssf.record">WriteAccessRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getWriteAccess()">getWriteAccess</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/record/WriteProtectRecord.html" title="class in org.apache.poi.hssf.record">WriteProtectRecord</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getWriteProtect()">getWriteProtect</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#insertSST()">insertSST</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;use this function to add a Shared String Table to an existing sheet (say
 generated by a different java api) without an sst....</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isSheetHidden(int)">isSheetHidden</A></B>(int&nbsp;sheetnum)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets the hidden flag for a given sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isSheetVeryHidden(int)">isSheetVeryHidden</A></B>(int&nbsp;sheetnum)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets the very hidden flag for a given sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isUsing1904DateWindowing()">isUsing1904DateWindowing</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Whether date windowing is based on 1/2/1904 or 1/1/1900.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isWriteProtected()">isWriteProtected</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;is the workbook protected with a password (not encrypted)?</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#linkExternalWorkbook(java.lang.String, org.apache.poi.ss.usermodel.Workbook)">linkExternalWorkbook</A></B>(java.lang.String&nbsp;name,
                     <A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;externalWorkbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#preSerialize()">preSerialize</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Perform any work necessary before the workbook is about to be serialized.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeBuiltinRecord(byte, int)">removeBuiltinRecord</A></B>(byte&nbsp;name,
                    int&nbsp;sheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Removes the specified Builtin NameRecord that matches the name and index</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeExFormatRecord(org.apache.poi.hssf.record.ExtendedFormatRecord)">removeExFormatRecord</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Removes the given ExtendedFormatRecord record from the
  file's list.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeExFormatRecord(int)">removeExFormatRecord</A></B>(int&nbsp;index)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Removes ExtendedFormatRecord record with given index from the
  file's list.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeFontRecord(org.apache.poi.hssf.record.FontRecord)">removeFontRecord</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A>&nbsp;rec)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Removes the given font record from the
  file's list.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeName(int)">removeName</A></B>(int&nbsp;nameIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;removes the name</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#removeSheet(int)">removeSheet</A></B>(int&nbsp;sheetIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#resolveNameXText(int, int)">resolveNameXText</A></B>(int&nbsp;refIndex,
                 int&nbsp;definedNameIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#serialize(int, byte[])">serialize</A></B>(int&nbsp;offset,
          byte[]&nbsp;data)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Serializes all records int the worksheet section into a big byte array.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#setSheetBof(int, int)">setSheetBof</A></B>(int&nbsp;sheetIndex,
            int&nbsp;pos)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the BOF for a given sheet</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#setSheetHidden(int, boolean)">setSheetHidden</A></B>(int&nbsp;sheetnum,
               boolean&nbsp;hidden)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hide or unhide a sheet</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#setSheetHidden(int, int)">setSheetHidden</A></B>(int&nbsp;sheetnum,
               int&nbsp;hidden)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hide or unhide a sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#setSheetName(int, java.lang.String)">setSheetName</A></B>(int&nbsp;sheetnum,
             java.lang.String&nbsp;sheetname)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sets the name for a given sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#setSheetOrder(java.lang.String, int)">setSheetOrder</A></B>(java.lang.String&nbsp;sheetname,
              int&nbsp;pos)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sets the order of appearance for a given sheet.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#unwriteProtectWorkbook()">unwriteProtectWorkbook</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;removes the write protect flag</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#updateNameCommentRecordCache(org.apache.poi.hssf.record.NameCommentRecord)">updateNameCommentRecordCache</A></B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record">NameCommentRecord</A>&nbsp;commentRecord)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If a <A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record"><CODE>NameCommentRecord</CODE></A> is added or the name it references
  is renamed, then this will update the lookup cache for it.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#updateNamesAfterCellShift(org.apache.poi.ss.formula.FormulaShifter)">updateNamesAfterCellShift</A></B>(<A HREF="../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</A>&nbsp;shifter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Updates named ranges due to moving of cells</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#writeProtectWorkbook(java.lang.String, java.lang.String)">writeProtectWorkbook</A></B>(java.lang.String&nbsp;password,
                     java.lang.String&nbsp;username)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;protect a workbook with a password (not encypted, just sets writeprotect
 flags and the password.</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ============ FIELD DETAIL =========== -->

<A NAME="field_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Field Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="WORKBOOK_DIR_ENTRY_NAMES"><!-- --></A><H3>
WORKBOOK_DIR_ENTRY_NAMES</H3>
<PRE>
public static final java.lang.String[] <B>WORKBOOK_DIR_ENTRY_NAMES</B></PRE>
<DL>
<DD>Normally, the Workbook will be in a POIFS Stream called 
  "Workbook". However, some weird XLS generators use "WORKBOOK"
  or "BOOK".
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="OLD_WORKBOOK_DIR_ENTRY_NAME"><!-- --></A><H3>
OLD_WORKBOOK_DIR_ENTRY_NAME</H3>
<PRE>
public static final java.lang.String <B>OLD_WORKBOOK_DIR_ENTRY_NAME</B></PRE>
<DL>
<DD>Name of older (pre-Excel 97) Workbook streams, which
  aren't supported by HSSFWorkbook, only by
  <A HREF="../../../../../org/apache/poi/hssf/extractor/OldExcelExtractor.html" title="class in org.apache.poi.hssf.extractor"><CODE>OldExcelExtractor</CODE></A>
<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../constant-values.html#org.apache.poi.hssf.model.InternalWorkbook.OLD_WORKBOOK_DIR_ENTRY_NAME">Constant Field Values</A></DL>
</DL>
<HR>

<A NAME="sst"><!-- --></A><H3>
sst</H3>
<PRE>
protected <A HREF="../../../../../org/apache/poi/hssf/record/SSTRecord.html" title="class in org.apache.poi.hssf.record">SSTRecord</A> <B>sst</B></PRE>
<DL>
<DD>this contains a reference to the SSTRecord so that new stings can be added
 to it.
<P>
<DL>
</DL>
</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="createWorkbook(java.util.List)"><!-- --></A><H3>
createWorkbook</H3>
<PRE>
public static <A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A> <B>createWorkbook</B>(java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A>&gt;&nbsp;recs)</PRE>
<DL>
<DD>read support  for low level
 API.  Pass in an array of Record objects, A Workbook
 object is constructed and passed back with all of its initialization set
 to the passed in records and references to those records held. Unlike Sheet
 workbook does not use an offset (its assumed to be 0) since its first in a file.
 If you need an offset then construct a new array with a 0 offset or write your
 own ;-p.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>recs</CODE> - an array of Record objects
<DT><B>Returns:</B><DD>Workbook object</DL>
</DD>
</DL>
<HR>

<A NAME="createWorkbook()"><!-- --></A><H3>
createWorkbook</H3>
<PRE>
public static <A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A> <B>createWorkbook</B>()</PRE>
<DL>
<DD>Creates an empty workbook object with three blank sheets and all the empty
 fields.  Use this to create a workbook from scratch.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getSpecificBuiltinRecord(byte, int)"><!-- --></A><H3>
getSpecificBuiltinRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>getSpecificBuiltinRecord</B>(byte&nbsp;name,
                                           int&nbsp;sheetNumber)</PRE>
<DL>
<DD>Retrieves the Builtin NameRecord that matches the name and index
 There shouldn't be too many names to make the sequential search too slow
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - byte representation of the builtin name to match<DD><CODE>sheetNumber</CODE> - 1-based sheet number
<DT><B>Returns:</B><DD>null if no builtin NameRecord matches</DL>
</DD>
</DL>
<HR>

<A NAME="removeBuiltinRecord(byte, int)"><!-- --></A><H3>
removeBuiltinRecord</H3>
<PRE>
public void <B>removeBuiltinRecord</B>(byte&nbsp;name,
                                int&nbsp;sheetIndex)</PRE>
<DL>
<DD>Removes the specified Builtin NameRecord that matches the name and index
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - byte representation of the builtin to match<DD><CODE>sheetIndex</CODE> - zero-based sheet reference</DL>
</DD>
</DL>
<HR>

<A NAME="getNumRecords()"><!-- --></A><H3>
getNumRecords</H3>
<PRE>
public int <B>getNumRecords</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getFontRecordAt(int)"><!-- --></A><H3>
getFontRecordAt</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A> <B>getFontRecordAt</B>(int&nbsp;idx)</PRE>
<DL>
<DD>gets the font record at the given index in the font table.  Remember
 "There is No Four" (someone at M$ must have gone to Rocky Horror one too
 many times)
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>idx</CODE> - the index to look at (0 or greater but NOT 4)
<DT><B>Returns:</B><DD>FontRecord located at the given index</DL>
</DD>
</DL>
<HR>

<A NAME="getFontIndex(org.apache.poi.hssf.record.FontRecord)"><!-- --></A><H3>
getFontIndex</H3>
<PRE>
public int <B>getFontIndex</B>(<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A>&nbsp;font)</PRE>
<DL>
<DD>Retrieves the index of the given font
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="createNewFont()"><!-- --></A><H3>
createNewFont</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A> <B>createNewFont</B>()</PRE>
<DL>
<DD>creates a new font record and adds it to the "font table".  This causes the
 boundsheets to move down one, extended formats to move down (so this function moves
 those pointers as well)
<P>
<DD><DL>

<DT><B>Returns:</B><DD>FontRecord that was just created</DL>
</DD>
</DL>
<HR>

<A NAME="removeFontRecord(org.apache.poi.hssf.record.FontRecord)"><!-- --></A><H3>
removeFontRecord</H3>
<PRE>
public void <B>removeFontRecord</B>(<A HREF="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</A>&nbsp;rec)</PRE>
<DL>
<DD>Removes the given font record from the
  file's list. This will make all
  subsequent font indicies drop by one,
  so you'll need to update those yourself!
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getNumberOfFontRecords()"><!-- --></A><H3>
getNumberOfFontRecords</H3>
<PRE>
public int <B>getNumberOfFontRecords</B>()</PRE>
<DL>
<DD>gets the number of font records
<P>
<DD><DL>

<DT><B>Returns:</B><DD>number of font records in the "font table"</DL>
</DD>
</DL>
<HR>

<A NAME="setSheetBof(int, int)"><!-- --></A><H3>
setSheetBof</H3>
<PRE>
public void <B>setSheetBof</B>(int&nbsp;sheetIndex,
                        int&nbsp;pos)</PRE>
<DL>
<DD>Sets the BOF for a given sheet
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetIndex</CODE> - the number of the sheet to set the positing of the bof for<DD><CODE>pos</CODE> - the actual bof position</DL>
</DD>
</DL>
<HR>

<A NAME="getBackupRecord()"><!-- --></A><H3>
getBackupRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/BackupRecord.html" title="class in org.apache.poi.hssf.record">BackupRecord</A> <B>getBackupRecord</B>()</PRE>
<DL>
<DD>Returns the position of the backup record.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setSheetName(int, java.lang.String)"><!-- --></A><H3>
setSheetName</H3>
<PRE>
public void <B>setSheetName</B>(int&nbsp;sheetnum,
                         java.lang.String&nbsp;sheetname)</PRE>
<DL>
<DD>sets the name for a given sheet.  If the boundsheet record doesn't exist and
 its only one more than we have, go ahead and create it.  If it's &gt; 1 more than
 we have, except
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetnum</CODE> - the sheet number (0 based)<DD><CODE>sheetname</CODE> - the name for the sheet</DL>
</DD>
</DL>
<HR>

<A NAME="doesContainsSheetName(java.lang.String, int)"><!-- --></A><H3>
doesContainsSheetName</H3>
<PRE>
public boolean <B>doesContainsSheetName</B>(java.lang.String&nbsp;name,
                                     int&nbsp;excludeSheetIdx)</PRE>
<DL>
<DD>Determines whether a workbook contains the provided sheet name.  For the purpose of
 comparison, long names are truncated to 31 chars.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - the name to test (case insensitive match)<DD><CODE>excludeSheetIdx</CODE> - the sheet to exclude from the check or -1 to include all sheets in the check.
<DT><B>Returns:</B><DD>true if the sheet contains the name, false otherwise.</DL>
</DD>
</DL>
<HR>

<A NAME="setSheetOrder(java.lang.String, int)"><!-- --></A><H3>
setSheetOrder</H3>
<PRE>
public void <B>setSheetOrder</B>(java.lang.String&nbsp;sheetname,
                          int&nbsp;pos)</PRE>
<DL>
<DD>sets the order of appearance for a given sheet.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetname</CODE> - the name of the sheet to reorder<DD><CODE>pos</CODE> - the position that we want to insert the sheet into (0 based)</DL>
</DD>
</DL>
<HR>

<A NAME="getSheetName(int)"><!-- --></A><H3>
getSheetName</H3>
<PRE>
public java.lang.String <B>getSheetName</B>(int&nbsp;sheetIndex)</PRE>
<DL>
<DD>gets the name for a given sheet.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetIndex</CODE> - the sheet number (0 based)
<DT><B>Returns:</B><DD>sheetname the name for the sheet</DL>
</DD>
</DL>
<HR>

<A NAME="isSheetHidden(int)"><!-- --></A><H3>
isSheetHidden</H3>
<PRE>
public boolean <B>isSheetHidden</B>(int&nbsp;sheetnum)</PRE>
<DL>
<DD>Gets the hidden flag for a given sheet.
 Note that a sheet could instead be
  set to be very hidden, which is different
  (<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isSheetVeryHidden(int)"><CODE>isSheetVeryHidden(int)</CODE></A>)
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetnum</CODE> - the sheet number (0 based)
<DT><B>Returns:</B><DD>True if sheet is hidden</DL>
</DD>
</DL>
<HR>

<A NAME="isSheetVeryHidden(int)"><!-- --></A><H3>
isSheetVeryHidden</H3>
<PRE>
public boolean <B>isSheetVeryHidden</B>(int&nbsp;sheetnum)</PRE>
<DL>
<DD>Gets the very hidden flag for a given sheet.
 This is different from the normal
  hidden flag
  (<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#isSheetHidden(int)"><CODE>isSheetHidden(int)</CODE></A>)
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetnum</CODE> - the sheet number (0 based)
<DT><B>Returns:</B><DD>True if sheet is very hidden</DL>
</DD>
</DL>
<HR>

<A NAME="setSheetHidden(int, boolean)"><!-- --></A><H3>
setSheetHidden</H3>
<PRE>
public void <B>setSheetHidden</B>(int&nbsp;sheetnum,
                           boolean&nbsp;hidden)</PRE>
<DL>
<DD>Hide or unhide a sheet
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetnum</CODE> - The sheet number<DD><CODE>hidden</CODE> - True to mark the sheet as hidden, false otherwise</DL>
</DD>
</DL>
<HR>

<A NAME="setSheetHidden(int, int)"><!-- --></A><H3>
setSheetHidden</H3>
<PRE>
public void <B>setSheetHidden</B>(int&nbsp;sheetnum,
                           int&nbsp;hidden)</PRE>
<DL>
<DD>Hide or unhide a sheet.
  0 = not hidden
  1 = hidden
  2 = very hidden.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetnum</CODE> - The sheet number<DD><CODE>hidden</CODE> - 0 for not hidden, 1 for hidden, 2 for very hidden</DL>
</DD>
</DL>
<HR>

<A NAME="getSheetIndex(java.lang.String)"><!-- --></A><H3>
getSheetIndex</H3>
<PRE>
public int <B>getSheetIndex</B>(java.lang.String&nbsp;name)</PRE>
<DL>
<DD>get the sheet's index
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - sheet name
<DT><B>Returns:</B><DD>sheet index or -1 if it was not found.</DL>
</DD>
</DL>
<HR>

<A NAME="removeSheet(int)"><!-- --></A><H3>
removeSheet</H3>
<PRE>
public void <B>removeSheet</B>(int&nbsp;sheetIndex)</PRE>
<DL>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetIndex</CODE> - zero based sheet index</DL>
</DD>
</DL>
<HR>

<A NAME="getNumSheets()"><!-- --></A><H3>
getNumSheets</H3>
<PRE>
public int <B>getNumSheets</B>()</PRE>
<DL>
<DD>returns the number of boundsheet objects contained in this workbook.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>number of BoundSheet records</DL>
</DD>
</DL>
<HR>

<A NAME="getNumExFormats()"><!-- --></A><H3>
getNumExFormats</H3>
<PRE>
public int <B>getNumExFormats</B>()</PRE>
<DL>
<DD>get the number of ExtendedFormat records contained in this workbook.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>int count of ExtendedFormat records</DL>
</DD>
</DL>
<HR>

<A NAME="getExFormatAt(int)"><!-- --></A><H3>
getExFormatAt</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A> <B>getExFormatAt</B>(int&nbsp;index)</PRE>
<DL>
<DD>gets the ExtendedFormatRecord at the given 0-based index
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>index</CODE> - of the Extended format record (0-based)
<DT><B>Returns:</B><DD>ExtendedFormatRecord at the given index</DL>
</DD>
</DL>
<HR>

<A NAME="removeExFormatRecord(org.apache.poi.hssf.record.ExtendedFormatRecord)"><!-- --></A><H3>
removeExFormatRecord</H3>
<PRE>
public void <B>removeExFormatRecord</B>(<A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec)</PRE>
<DL>
<DD>Removes the given ExtendedFormatRecord record from the
  file's list. This will make all
  subsequent font indicies drop by one,
  so you'll need to update those yourself!
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="removeExFormatRecord(int)"><!-- --></A><H3>
removeExFormatRecord</H3>
<PRE>
public void <B>removeExFormatRecord</B>(int&nbsp;index)</PRE>
<DL>
<DD>Removes ExtendedFormatRecord record with given index from the
  file's list. This will make all
  subsequent font indicies drop by one,
  so you'll need to update those yourself!
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>index</CODE> - of the Extended format record (0-based)</DL>
</DD>
</DL>
<HR>

<A NAME="createCellXF()"><!-- --></A><H3>
createCellXF</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A> <B>createCellXF</B>()</PRE>
<DL>
<DD>creates a new Cell-type Extended Format Record and adds it to the end of
  ExtendedFormatRecords collection
<P>
<DD><DL>

<DT><B>Returns:</B><DD>ExtendedFormatRecord that was created</DL>
</DD>
</DL>
<HR>

<A NAME="getStyleRecord(int)"><!-- --></A><H3>
getStyleRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/StyleRecord.html" title="class in org.apache.poi.hssf.record">StyleRecord</A> <B>getStyleRecord</B>(int&nbsp;xfIndex)</PRE>
<DL>
<DD>Returns the StyleRecord for the given
  xfIndex, or null if that ExtendedFormat doesn't
  have a Style set.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="createStyleRecord(int)"><!-- --></A><H3>
createStyleRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/StyleRecord.html" title="class in org.apache.poi.hssf.record">StyleRecord</A> <B>createStyleRecord</B>(int&nbsp;xfIndex)</PRE>
<DL>
<DD>Creates a new StyleRecord, for the given Extended
  Format index, and adds it onto the end of the
  records collection
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="addSSTString(org.apache.poi.hssf.record.common.UnicodeString)"><!-- --></A><H3>
addSSTString</H3>
<PRE>
public int <B>addSSTString</B>(<A HREF="../../../../../org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</A>&nbsp;string)</PRE>
<DL>
<DD>Adds a string to the SST table and returns its index (if its a duplicate
 just returns its index and update the counts) ASSUMES compressed unicode
 (meaning 8bit)
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>string</CODE> - the string to be added to the SSTRecord
<DT><B>Returns:</B><DD>index of the string within the SSTRecord</DL>
</DD>
</DL>
<HR>

<A NAME="getSSTString(int)"><!-- --></A><H3>
getSSTString</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/common/UnicodeString.html" title="class in org.apache.poi.hssf.record.common">UnicodeString</A> <B>getSSTString</B>(int&nbsp;str)</PRE>
<DL>
<DD>given an index into the SST table, this function returns the corresponding String value
<P>
<DD><DL>

<DT><B>Returns:</B><DD>String containing the SST String</DL>
</DD>
</DL>
<HR>

<A NAME="insertSST()"><!-- --></A><H3>
insertSST</H3>
<PRE>
public void <B>insertSST</B>()</PRE>
<DL>
<DD>use this function to add a Shared String Table to an existing sheet (say
 generated by a different java api) without an sst....
<P>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createExtendedSST()"><CODE>createExtendedSST()</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/record/SSTRecord.html" title="class in org.apache.poi.hssf.record"><CODE>SSTRecord</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="serialize(int, byte[])"><!-- --></A><H3>
serialize</H3>
<PRE>
public int <B>serialize</B>(int&nbsp;offset,
                     byte[]&nbsp;data)</PRE>
<DL>
<DD>Serializes all records int the worksheet section into a big byte array. Use
 this to write the Workbook out.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>offset</CODE> - of the data to be written<DD><CODE>data</CODE> - array of bytes to write this to</DL>
</DD>
</DL>
<HR>

<A NAME="preSerialize()"><!-- --></A><H3>
preSerialize</H3>
<PRE>
public void <B>preSerialize</B>()</PRE>
<DL>
<DD>Perform any work necessary before the workbook is about to be serialized.

 Include in it ant code that modifies the workbook record stream and affects its size.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getSize()"><!-- --></A><H3>
getSize</H3>
<PRE>
public int <B>getSize</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="linkExternalWorkbook(java.lang.String, org.apache.poi.ss.usermodel.Workbook)"><!-- --></A><H3>
linkExternalWorkbook</H3>
<PRE>
public int <B>linkExternalWorkbook</B>(java.lang.String&nbsp;name,
                                <A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;externalWorkbook)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="findSheetFirstNameFromExternSheet(int)"><!-- --></A><H3>
findSheetFirstNameFromExternSheet</H3>
<PRE>
public java.lang.String <B>findSheetFirstNameFromExternSheet</B>(int&nbsp;externSheetIndex)</PRE>
<DL>
<DD>Finds the first sheet name by his extern sheet index
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>externSheetIndex</CODE> - extern sheet index
<DT><B>Returns:</B><DD>first sheet name.</DL>
</DD>
</DL>
<HR>

<A NAME="findSheetLastNameFromExternSheet(int)"><!-- --></A><H3>
findSheetLastNameFromExternSheet</H3>
<PRE>
public java.lang.String <B>findSheetLastNameFromExternSheet</B>(int&nbsp;externSheetIndex)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getExternalSheet(int)"><!-- --></A><H3>
getExternalSheet</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</A> <B>getExternalSheet</B>(int&nbsp;externSheetIndex)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getExternalName(int, int)"><!-- --></A><H3>
getExternalName</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</A> <B>getExternalName</B>(int&nbsp;externSheetIndex,
                                                       int&nbsp;externNameIndex)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getFirstSheetIndexFromExternSheetIndex(int)"><!-- --></A><H3>
getFirstSheetIndexFromExternSheetIndex</H3>
<PRE>
public int <B>getFirstSheetIndexFromExternSheetIndex</B>(int&nbsp;externSheetNumber)</PRE>
<DL>
<DD>Finds the (first) sheet index for a particular external sheet number.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>externSheetNumber</CODE> - The external sheet number to convert
<DT><B>Returns:</B><DD>The index to the sheet found.</DL>
</DD>
</DL>
<HR>

<A NAME="getLastSheetIndexFromExternSheetIndex(int)"><!-- --></A><H3>
getLastSheetIndexFromExternSheetIndex</H3>
<PRE>
public int <B>getLastSheetIndexFromExternSheetIndex</B>(int&nbsp;externSheetNumber)</PRE>
<DL>
<DD>Finds the last sheet index for a particular external sheet number,
  which may be the same as the first (except for multi-sheet references)
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>externSheetNumber</CODE> - The external sheet number to convert
<DT><B>Returns:</B><DD>The index to the sheet found.</DL>
</DD>
</DL>
<HR>

<A NAME="checkExternSheet(int)"><!-- --></A><H3>
checkExternSheet</H3>
<PRE>
public short <B>checkExternSheet</B>(int&nbsp;sheetNumber)</PRE>
<DL>
<DD>Returns the extern sheet number for specific sheet number.
 If this sheet doesn't exist in extern sheet, add it
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheetNumber</CODE> - local sheet number
<DT><B>Returns:</B><DD>index to extern sheet</DL>
</DD>
</DL>
<HR>

<A NAME="checkExternSheet(int, int)"><!-- --></A><H3>
checkExternSheet</H3>
<PRE>
public short <B>checkExternSheet</B>(int&nbsp;firstSheetNumber,
                              int&nbsp;lastSheetNumber)</PRE>
<DL>
<DD>Returns the extern sheet number for specific range of sheets.
 If this sheet range doesn't exist in extern sheet, add it
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>firstSheetNumber</CODE> - first local sheet number<DD><CODE>lastSheetNumber</CODE> - last local sheet number
<DT><B>Returns:</B><DD>index to extern sheet</DL>
</DD>
</DL>
<HR>

<A NAME="getExternalSheetIndex(java.lang.String, java.lang.String)"><!-- --></A><H3>
getExternalSheetIndex</H3>
<PRE>
public int <B>getExternalSheetIndex</B>(java.lang.String&nbsp;workbookName,
                                 java.lang.String&nbsp;sheetName)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getExternalSheetIndex(java.lang.String, java.lang.String, java.lang.String)"><!-- --></A><H3>
getExternalSheetIndex</H3>
<PRE>
public int <B>getExternalSheetIndex</B>(java.lang.String&nbsp;workbookName,
                                 java.lang.String&nbsp;firstSheetName,
                                 java.lang.String&nbsp;lastSheetName)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getNumNames()"><!-- --></A><H3>
getNumNames</H3>
<PRE>
public int <B>getNumNames</B>()</PRE>
<DL>
<DD>gets the total number of names
<P>
<DD><DL>

<DT><B>Returns:</B><DD>number of names</DL>
</DD>
</DL>
<HR>

<A NAME="getNameRecord(int)"><!-- --></A><H3>
getNameRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>getNameRecord</B>(int&nbsp;index)</PRE>
<DL>
<DD>gets the name record
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>index</CODE> - name index
<DT><B>Returns:</B><DD>name record</DL>
</DD>
</DL>
<HR>

<A NAME="getNameCommentRecord(org.apache.poi.hssf.record.NameRecord)"><!-- --></A><H3>
getNameCommentRecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record">NameCommentRecord</A> <B>getNameCommentRecord</B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A>&nbsp;nameRecord)</PRE>
<DL>
<DD>gets the name comment record
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>nameRecord</CODE> - name record who's comment is required.
<DT><B>Returns:</B><DD>name comment record or <code>null</code> if there isn't one for the given name.</DL>
</DD>
</DL>
<HR>

<A NAME="createName()"><!-- --></A><H3>
createName</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>createName</B>()</PRE>
<DL>
<DD>creates new name
<P>
<DD><DL>

<DT><B>Returns:</B><DD>new name record</DL>
</DD>
</DL>
<HR>

<A NAME="addName(org.apache.poi.hssf.record.NameRecord)"><!-- --></A><H3>
addName</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>addName</B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A>&nbsp;name)</PRE>
<DL>
<DD>creates new name
<P>
<DD><DL>

<DT><B>Returns:</B><DD>new name record</DL>
</DD>
</DL>
<HR>

<A NAME="createBuiltInName(byte, int)"><!-- --></A><H3>
createBuiltInName</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>createBuiltInName</B>(byte&nbsp;builtInName,
                                    int&nbsp;sheetNumber)</PRE>
<DL>
<DD>Generates a NameRecord to represent a built-in region
<P>
<DD><DL>

<DT><B>Returns:</B><DD>a new NameRecord</DL>
</DD>
</DL>
<HR>

<A NAME="removeName(int)"><!-- --></A><H3>
removeName</H3>
<PRE>
public void <B>removeName</B>(int&nbsp;nameIndex)</PRE>
<DL>
<DD>removes the name
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>nameIndex</CODE> - name index</DL>
</DD>
</DL>
<HR>

<A NAME="updateNameCommentRecordCache(org.apache.poi.hssf.record.NameCommentRecord)"><!-- --></A><H3>
updateNameCommentRecordCache</H3>
<PRE>
public void <B>updateNameCommentRecordCache</B>(<A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record">NameCommentRecord</A>&nbsp;commentRecord)</PRE>
<DL>
<DD>If a <A HREF="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record"><CODE>NameCommentRecord</CODE></A> is added or the name it references
  is renamed, then this will update the lookup cache for it.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getFormat(java.lang.String, boolean)"><!-- --></A><H3>
getFormat</H3>
<PRE>
public short <B>getFormat</B>(java.lang.String&nbsp;format,
                       boolean&nbsp;createIfNotFound)</PRE>
<DL>
<DD>Returns a format index that matches the passed in format.  It does not tie into HSSFDataFormat.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>format</CODE> - the format string<DD><CODE>createIfNotFound</CODE> - creates a new format if format not found
<DT><B>Returns:</B><DD>the format id of a format that matches or -1 if none found and createIfNotFound</DL>
</DD>
</DL>
<HR>

<A NAME="getFormats()"><!-- --></A><H3>
getFormats</H3>
<PRE>
public java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/FormatRecord.html" title="class in org.apache.poi.hssf.record">FormatRecord</A>&gt; <B>getFormats</B>()</PRE>
<DL>
<DD>Returns the list of FormatRecords in the workbook.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>ArrayList of FormatRecords in the notebook</DL>
</DD>
</DL>
<HR>

<A NAME="createFormat(java.lang.String)"><!-- --></A><H3>
createFormat</H3>
<PRE>
public int <B>createFormat</B>(java.lang.String&nbsp;formatString)</PRE>
<DL>
<DD>Creates a FormatRecord, inserts it, and returns the index code.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>formatString</CODE> - the format string
<DT><B>Returns:</B><DD>the index code of the format record.<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/record/FormatRecord.html" title="class in org.apache.poi.hssf.record"><CODE>FormatRecord</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record"><CODE>Record</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="findFirstRecordBySid(short)"><!-- --></A><H3>
findFirstRecordBySid</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A> <B>findFirstRecordBySid</B>(short&nbsp;sid)</PRE>
<DL>
<DD>Returns the first occurance of a record matching a particular sid.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="findFirstRecordLocBySid(short)"><!-- --></A><H3>
findFirstRecordLocBySid</H3>
<PRE>
public int <B>findFirstRecordLocBySid</B>(short&nbsp;sid)</PRE>
<DL>
<DD>Returns the index of a record matching a particular sid.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sid</CODE> - The sid of the record to match
<DT><B>Returns:</B><DD>The index of -1 if no match made.</DL>
</DD>
</DL>
<HR>

<A NAME="findNextRecordBySid(short, int)"><!-- --></A><H3>
findNextRecordBySid</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A> <B>findNextRecordBySid</B>(short&nbsp;sid,
                                  int&nbsp;pos)</PRE>
<DL>
<DD>Returns the next occurance of a record matching a particular sid.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getHyperlinks()"><!-- --></A><H3>
getHyperlinks</H3>
<PRE>
public java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/HyperlinkRecord.html" title="class in org.apache.poi.hssf.record">HyperlinkRecord</A>&gt; <B>getHyperlinks</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getRecords()"><!-- --></A><H3>
getRecords</H3>
<PRE>
public java.util.List&lt;<A HREF="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</A>&gt; <B>getRecords</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="isUsing1904DateWindowing()"><!-- --></A><H3>
isUsing1904DateWindowing</H3>
<PRE>
public boolean <B>isUsing1904DateWindowing</B>()</PRE>
<DL>
<DD>Whether date windowing is based on 1/2/1904 or 1/1/1900.
 Some versions of Excel (Mac) can save workbooks using 1904 date windowing.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>true if using 1904 date windowing</DL>
</DD>
</DL>
<HR>

<A NAME="getCustomPalette()"><!-- --></A><H3>
getCustomPalette</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/PaletteRecord.html" title="class in org.apache.poi.hssf.record">PaletteRecord</A> <B>getCustomPalette</B>()</PRE>
<DL>
<DD>Returns the custom palette in use for this workbook; if a custom palette record
 does not exist, then it is created.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="findDrawingGroup()"><!-- --></A><H3>
findDrawingGroup</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/model/DrawingManager2.html" title="class in org.apache.poi.hssf.model">DrawingManager2</A> <B>findDrawingGroup</B>()</PRE>
<DL>
<DD>Finds the primary drawing group, if one already exists
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="createDrawingGroup()"><!-- --></A><H3>
createDrawingGroup</H3>
<PRE>
public void <B>createDrawingGroup</B>()</PRE>
<DL>
<DD>Creates a primary drawing group record.  If it already
  exists then it's modified.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getWindowOne()"><!-- --></A><H3>
getWindowOne</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/WindowOneRecord.html" title="class in org.apache.poi.hssf.record">WindowOneRecord</A> <B>getWindowOne</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getBSERecord(int)"><!-- --></A><H3>
getBSERecord</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/ddf/EscherBSERecord.html" title="class in org.apache.poi.ddf">EscherBSERecord</A> <B>getBSERecord</B>(int&nbsp;pictureIndex)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="addBSERecord(org.apache.poi.ddf.EscherBSERecord)"><!-- --></A><H3>
addBSERecord</H3>
<PRE>
public int <B>addBSERecord</B>(<A HREF="../../../../../org/apache/poi/ddf/EscherBSERecord.html" title="class in org.apache.poi.ddf">EscherBSERecord</A>&nbsp;e)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getDrawingManager()"><!-- --></A><H3>
getDrawingManager</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/model/DrawingManager2.html" title="class in org.apache.poi.hssf.model">DrawingManager2</A> <B>getDrawingManager</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getWriteProtect()"><!-- --></A><H3>
getWriteProtect</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/WriteProtectRecord.html" title="class in org.apache.poi.hssf.record">WriteProtectRecord</A> <B>getWriteProtect</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getWriteAccess()"><!-- --></A><H3>
getWriteAccess</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/WriteAccessRecord.html" title="class in org.apache.poi.hssf.record">WriteAccessRecord</A> <B>getWriteAccess</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getFileSharing()"><!-- --></A><H3>
getFileSharing</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/FileSharingRecord.html" title="class in org.apache.poi.hssf.record">FileSharingRecord</A> <B>getFileSharing</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="isWriteProtected()"><!-- --></A><H3>
isWriteProtected</H3>
<PRE>
public boolean <B>isWriteProtected</B>()</PRE>
<DL>
<DD>is the workbook protected with a password (not encrypted)?
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="writeProtectWorkbook(java.lang.String, java.lang.String)"><!-- --></A><H3>
writeProtectWorkbook</H3>
<PRE>
public void <B>writeProtectWorkbook</B>(java.lang.String&nbsp;password,
                                 java.lang.String&nbsp;username)</PRE>
<DL>
<DD>protect a workbook with a password (not encypted, just sets writeprotect
 flags and the password.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>password</CODE> - to set</DL>
</DD>
</DL>
<HR>

<A NAME="unwriteProtectWorkbook()"><!-- --></A><H3>
unwriteProtectWorkbook</H3>
<PRE>
public void <B>unwriteProtectWorkbook</B>()</PRE>
<DL>
<DD>removes the write protect flag
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="resolveNameXText(int, int)"><!-- --></A><H3>
resolveNameXText</H3>
<PRE>
public java.lang.String <B>resolveNameXText</B>(int&nbsp;refIndex,
                                         int&nbsp;definedNameIndex)</PRE>
<DL>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>refIndex</CODE> - Index to REF entry in EXTERNSHEET record in the Link Table<DD><CODE>definedNameIndex</CODE> - zero-based to DEFINEDNAME or EXTERNALNAME record
<DT><B>Returns:</B><DD>the string representation of the defined or external name</DL>
</DD>
</DL>
<HR>

<A NAME="getNameXPtg(java.lang.String, int, org.apache.poi.ss.formula.udf.UDFFinder)"><!-- --></A><H3>
getNameXPtg</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</A> <B>getNameXPtg</B>(java.lang.String&nbsp;name,
                            int&nbsp;sheetRefIndex,
                            <A HREF="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</A>&nbsp;udf)</PRE>
<DL>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - the  name of an external function, typically a name of a UDF<DD><CODE>sheetRefIndex</CODE> - the sheet ref index, or -1 if not known<DD><CODE>udf</CODE> - locator of user-defiend functions to resolve names of VBA and Add-In functions
<DT><B>Returns:</B><DD>the external name or null</DL>
</DD>
</DL>
<HR>

<A NAME="getNameXPtg(java.lang.String, org.apache.poi.ss.formula.udf.UDFFinder)"><!-- --></A><H3>
getNameXPtg</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</A> <B>getNameXPtg</B>(java.lang.String&nbsp;name,
                            <A HREF="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</A>&nbsp;udf)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="cloneDrawings(org.apache.poi.hssf.model.InternalSheet)"><!-- --></A><H3>
cloneDrawings</H3>
<PRE>
public void <B>cloneDrawings</B>(<A HREF="../../../../../org/apache/poi/hssf/model/InternalSheet.html" title="class in org.apache.poi.hssf.model">InternalSheet</A>&nbsp;sheet)</PRE>
<DL>
<DD>Check if the cloned sheet has drawings. If yes, then allocate a new drawing group ID and
 re-generate shape IDs
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sheet</CODE> - the cloned sheet</DL>
</DD>
</DL>
<HR>

<A NAME="cloneFilter(int, int)"><!-- --></A><H3>
cloneFilter</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</A> <B>cloneFilter</B>(int&nbsp;filterDbNameIndex,
                              int&nbsp;newSheetIndex)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="updateNamesAfterCellShift(org.apache.poi.ss.formula.FormulaShifter)"><!-- --></A><H3>
updateNamesAfterCellShift</H3>
<PRE>
public void <B>updateNamesAfterCellShift</B>(<A HREF="../../../../../org/apache/poi/ss/formula/FormulaShifter.html" title="class in org.apache.poi.ss.formula">FormulaShifter</A>&nbsp;shifter)</PRE>
<DL>
<DD>Updates named ranges due to moving of cells
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getRecalcId()"><!-- --></A><H3>
getRecalcId</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/record/RecalcIdRecord.html" title="class in org.apache.poi.hssf.record">RecalcIdRecord</A> <B>getRecalcId</B>()</PRE>
<DL>
<DD>Get or create RecalcIdRecord
<P>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setForceFormulaRecalculation(boolean)"><CODE>HSSFWorkbook.setForceFormulaRecalculation(boolean)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="changeExternalReference(java.lang.String, java.lang.String)"><!-- --></A><H3>
changeExternalReference</H3>
<PRE>
public boolean <B>changeExternalReference</B>(java.lang.String&nbsp;oldUrl,
                                       java.lang.String&nbsp;newUrl)</PRE>
<DL>
<DD>Changes an external referenced file to another file.
 A formular in Excel which refers a cell in another file is saved in two parts: 
 The referenced file is stored in an reference table. the row/cell information is saved separate.
 This method invokation will only change the reference in the lookup-table itself.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>oldUrl</CODE> - The old URL to search for and which is to be replaced<DD><CODE>newUrl</CODE> - The URL replacement
<DT><B>Returns:</B><DD>true if the oldUrl was found and replaced with newUrl. Otherwise false</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/InternalWorkbook.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/InternalSheet.UnsupportedBOFType.html" title="class in org.apache.poi.hssf.model"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/model/LineShape.html" title="class in org.apache.poi.hssf.model"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?org/apache/poi/hssf/model/InternalWorkbook.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="InternalWorkbook.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>

                <i>Copyright 2016 The Apache Software Foundation or
        its licensors, as applicable.</i>
            
</BODY>
</HTML>
